﻿Delete [RoleToAction]
DELETE [webpages_UsersInRoles]

Delete [Action]
Delete [UserProfile]
Delete [webpages_Membership]
DElete [webpages_Roles]


SET IDENTITY_INSERT [dbo].[UserProfile] ON 
GO
INSERT [dbo].[UserProfile] ([UserId], [UserName]) VALUES (1, N'admin')
GO
SET IDENTITY_INSERT [dbo].[UserProfile] OFF
GO

INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate], [IsDeleted], [Email]) 
	VALUES (1, CAST(0x0000A14B00EFFA0F AS DateTime), NULL, 1, CAST(0x0000A1660119D55F AS DateTime), 0, N'2C0C5A0E64A51BA3D2A03C2FC070FAF6', CAST(0x0000A14B00EFFA0F AS DateTime), N'', NULL, NULL, 0, N'Admin@a.com')
GO

INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (1, N'Viewer')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (2, N'Contributer')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (3, N'Manager')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (4, N'Admin')
INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (5, N'HighViewer')

INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (1, N'User/Index')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (2, N'User/Create')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (3, N'User/GetUsers')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (4, N'User/Add')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (5, N'User/Update')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (6, N'User/Delete')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (7, N'User/ResetPassword')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (8, N'Category/Index')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (9, N'Category/Edit')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (10, N'Category/GetCategories')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (11, N'Category/Delete')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (12, N'Category/Add')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (13, N'Apply/Index')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (14, N'Picture/Index')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (15, N'Picture/GetPictures')

INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (16, N'Picture/GetPlaceValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (17, N'Picture/GetSexValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (18, N'Picture/GetItemValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (19, N'Picture/GetColorValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (20, N'Picture/GetStyleValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (21, N'Picture/GetLengthValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (22, N'Picture/GetCollarValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (23, N'Picture/GetFrontValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (24, N'Picture/GetSleeveValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (25, N'Picture/GetSweaterTextureValues')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (40, N'Picture/GetTypeValues')

INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (26, N'Picture/GetPicturesWithFilter')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (27, N'Picture/Update')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (28, N'Picture/Detail')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (29, N'Picture/Delete')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (30, N'Picture/DownloadExcel')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (31, N'Picture/DownloadExcelWithFilters')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (32, N'Picture/ApplyRequest')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (33, N'Apply/GetRequests')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (34, N'Apply/ApproveAndDownload')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (35, N'Apply/Reject')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (36, N'Apply/Add')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (37, N'Apply/Update')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (38, N'Apply/RequesterIndex')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (39, N'Apply/Delete')

INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (41, N'Report/Index')
INSERT [dbo].[Action] ([ActionId], [ActionUrl]) VALUES (42, N'Report/GetReport')

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (1, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (2, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (3, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (4, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (5, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (6, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (7, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (8, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (9, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (10, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (11, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (12, 4)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (13, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (13, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (14, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (14, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (14, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (14, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (15, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (15, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (15, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (15, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (16, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (16, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (16, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (16, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (17, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (17, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (17, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (17, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (17, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (18, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (18, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (18, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (18, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (18, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (19, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (19, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (19, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (19, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (19, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (20, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (20, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (20, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (20, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (20, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (21, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (21, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (21, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (21, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (21, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (22, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (22, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (22, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (22, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (22, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (23, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (23, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (23, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (23, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (23, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (24, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (24, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (24, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (24, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (24, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (25, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (25, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (25, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (25, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (25, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (26, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (26, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (26, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (26, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (26, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (27, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (27, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (27, 4)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (28, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (28, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (28, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (28, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (28, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (29, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (29, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (29, 4)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (30, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (30, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (31, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (31, 4)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (32, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (33, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (32, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (33, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (33, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (33, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (34, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (34, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (35, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (35, 4)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (35, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (36, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (37, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (38, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (39, 1)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (35, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (36, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (37, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (38, 5)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (39, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (40, 1)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (40, 2)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (40, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (40, 4)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (40, 5)

INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (41, 3)
INSERT [dbo].[RoleToAction] ([ActionId], [RoleId]) VALUES (42, 3)

INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (1, 4)


INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (1, N'Year', 0)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (2, N'Month', 0)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (3, N'Date', 0)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (4, N'Place', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (5, N'Sex', 0)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (6, N'Item', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (7, N'Color', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (8, N'Style', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (9, N'Length', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (10, N'Collar', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (11, N'Front', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (12, N'Sleeve', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (13, N'Sweater Texture', 1)
INSERT [dbo].[Category] ([CategoryId], [CategoryName], [ShowForAdmin]) VALUES (14, N'Type', 0)

-- sex values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 5, 'Men', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 5, 'Women', GETDATE(), 1, GETDATE(), '')

-- place values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 4, '上海 Casual', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 4, '上海 Office', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 4, '上海 Univesity', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('11', 0, 4, '沈阳 Casual', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('21', 0, 4, '北京 Casual', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('31', 0, 4, '深圳 Casual', GETDATE(), 1, GETDATE(), '')

-- item values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('101', 0, 6, 'Short Jumper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('102', 0, 6, 'Blouson', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('103', 0, 6, 'Baseball Jumper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('104', 0, 6, 'Topper Jumpr', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('105', 0, 6, 'Military Jumper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('106', 0, 6, 'Windbreaker', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('107', 0, 6, 'Safari Jumper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('108', 0, 6, 'Wool Jumper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('109', 0, 6, 'Denim Jacket', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('110', 0, 6, 'Lace Jacket', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('111', 0, 6, 'Leather Jacket', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('112', 0, 6, 'Trench Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('129', 0, 6, 'Jumper ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('131', 0, 6, 'Casual Jacket', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('132', 0, 6, 'Suit Jacket', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('141', 0, 6, 'Front Stitch Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('142', 0, 6, 'Low Weight Front Stitch Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('143', 0, 6, 'Non Stitch Middle Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('144', 0, 6, 'Non Stitch Half Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('145', 0, 6, 'Non Stitch Long Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('146', 0, 6, 'Qulting Parka', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('159', 0, 6, 'Parka ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('161', 0, 6, 'Single Breast Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('162', 0, 6, 'Single Breast Coat(+ Fur)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('163', 0, 6, 'Double Breast Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('164', 0, 6, 'Double Breast Coat(+ Fur)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('165', 0, 6, 'Duffle Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('166', 0, 6, 'Pea Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('167', 0, 6, 'Cape Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('168', 0, 6, 'Wrap Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('169', 0, 6, 'Fur Coat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('179', 0, 6, 'Coat ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('201', 0, 6, 'Casual Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('202', 0, 6, 'Wool Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('203', 0, 6, 'Denim Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('204', 0, 6, 'Lace Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('205', 0, 6, 'Leather Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('211', 0, 6, 'Fur Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('221', 0, 6, 'Front Stitch Parka Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('222', 0, 6, 'Non Stitch Parka Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('231', 0, 6, 'Sweater Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('241', 0, 6, 'Knit Vest', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('299', 0, 6, 'Vest ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('301', 0, 6, 'Woven One Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('302', 0, 6, 'Knit One Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('303', 0, 6, 'Sweater One Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('304', 0, 6, 'Denim One Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('305', 0, 6, 'Lace One Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('306', 0, 6, 'Textile Mixed One-Piece', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('307', 0, 6, 'Jumper Suit', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('399', 0, 6, 'One Piece ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('401', 0, 6, 'Solid Shirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('402', 0, 6, 'Blouse', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('403', 0, 6, 'Denim Shirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('404', 0, 6, 'Lace Shirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('405', 0, 6, 'Outer Shirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('406', 0, 6, 'Pattern Shirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('419', 0, 6, 'Shirt ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('499', 0, 6, 'Shirt Don’t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('501', 0, 6, 'Pull Over Sweater', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('502', 0, 6, 'Cadigan Sweater', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('503', 0, 6, 'Outer Sweater', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('519', 0, 6, 'Sweater ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('599', 0, 6, 'Sweater Don’t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('601', 0, 6, 'Solid MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('602', 0, 6, 'FG MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('603', 0, 6, 'Polapolis MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('604', 0, 6, 'Fake Fur MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('605', 0, 6, 'Outer MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('606', 0, 6, 'Pattern MTM', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('607', 0, 6, 'Track Top', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('619', 0, 6, 'MTM ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('699', 0, 6, 'MTM Don’t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('701', 0, 6, 'Knit Collar Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('702', 0, 6, 'Woven Collar Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('703', 0, 6, 'Solid Running Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('704', 0, 6, 'Graphic Running Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('705', 0, 6, 'Cardigan Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('706', 0, 6, 'Lace Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('707', 0, 6, 'Pattern Running Tee', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('708', 0, 6, 'Camisole ', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('719', 0, 6, 'Tee ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('799', 0, 6, 'Tee Don’t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('801', 0, 6, 'Cotton Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('802', 0, 6, 'Woven Training Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('803', 0, 6, 'Suit Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('804', 0, 6, 'Wool Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('805', 0, 6, 'Leather Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('806', 0, 6, 'Lace Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('807', 0, 6, 'Leggings', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('808', 0, 6, 'Knit Pants', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('819', 0, 6, 'Pants ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('821', 0, 6, 'Basic Jeans', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('829', 0, 6, 'Jeans ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('831', 0, 6, 'Overall', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('901', 0, 6, 'Woven Skirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('902', 0, 6, 'Knit Skirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('903', 0, 6, 'Jeans Skirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('904', 0, 6, 'Leather Skirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('905', 0, 6, 'Lace Skirt', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('919', 0, 6, 'Skirt ETC', GETDATE(), 1, GETDATE(), '')

-- color values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 7, 'Black', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 7, 'Grey', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 7, 'White', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 7, 'Ivory', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 7, 'Red', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('6', 0, 7, 'Pink', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 7, 'Orange', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('8', 0, 7, 'Yellow', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('9', 0, 7, 'Beige', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('10', 0, 7, 'Brown', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('11', 0, 7, 'Green', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('12', 0, 7, 'Khaki', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('13', 0, 7, 'Blue', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('14', 0, 7, 'Navy', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('15', 0, 7, 'Purple', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('16', 0, 7, 'Color Match', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('17', 0, 7, 'Solid ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('21', 0, 7, 'Stripe', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('22', 0, 7, 'Check', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('23', 0, 7, 'Dot', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('24', 0, 7, 'Flower', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('25', 0, 7, 'Animal', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('26', 0, 7, 'Geometiric', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('27', 0, 7, 'Paisley', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('28', 0, 7, 'Solid + Pattern', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('29', 0, 7, 'Pattern ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('30', 0, 7, 'Argyle ', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('31', 0, 7, 'Hound''s Tooth', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('32', 0, 7, 'Nordic', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('41', 0, 7, 'Dark Tone(Jeans)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('42', 0, 7, 'Middle Tone(Jeans)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('43', 0, 7, 'Light Tone(Jeans)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('44', 0, 7, 'Black Tone(Jeans)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('45', 0, 7, 'Grey Tone(Jeans)', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('46', 0, 7, 'One Wash', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('47', 0, 7, 'Jeans ETC', GETDATE(), 1, GETDATE(), '')

-- style values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 8, 'A-Line', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 8, 'X-Line', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 8, 'H-Line', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 8, 'O-Line', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 8, 'Fit-Line', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('6', 0, 8, 'Wide', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 8, 'Silhouette  ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('21', 0, 8, 'Straight', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('22', 0, 8, 'Skinny', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('23', 0, 8, 'Boot Cut', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('24', 0, 8, 'Loose', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('25', 0, 8, 'Baggy', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('26', 0, 8, 'Cargo', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('27', 0, 8, 'Slim Straight', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 8, 'Don''t See', GETDATE(), 1, GETDATE(), '')


-- length values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('S', 0, 9, 'Short', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('M', 0, 9, 'Middle', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 9, '2~3부', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 9, '4~5부', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 9, '6~7부', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('9', 0, 9, '8~9부', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('0', 0, 9, '10부', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('9', 0, 9, 'Don''t Know', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 9, 'Don''t See', GETDATE(), 1, GETDATE(), '')


-- Collar values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 10, 'Flat', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 10, 'Tailored', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 10, 'Stand', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 10, 'Shawl', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 10, 'Hood', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('6', 0, 10, 'Hood Separated', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 10, 'Round Neck', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('8', 0, 10, 'V-Neck', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('9', 0, 10, 'Square Neck', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('10', 0, 10, 'Polo', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('11', 0, 10, 'Bow', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('12', 0, 10, 'Ruffle', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('13', 0, 10, 'Double Collar', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('14', 0, 10, 'Collar ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 10, 'Don''t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('99', 0, 10, 'Null', GETDATE(), 1, GETDATE(), '')

--  Front values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 11, 'Pull Over', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 11, 'Zipper', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 11, 'Single Button', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 11, 'Double Button', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 11, 'Plaket Front', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('6', 0, 11, 'Toggle', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 11, 'Front ETC', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 11, 'Don''t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('99', 0, 11, 'Null', GETDATE(), 1, GETDATE(), '')

-- Sleeve values
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 12, 'Long Sleeve', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 12, 'Half Sleeve', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 12, 'Short Sleeve', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 12, 'Sleeveless', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 12, 'Don''t Know', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 12, 'Don''t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('99', 0, 12, 'Null', GETDATE(), 1, GETDATE(), '')

-- Sweater texture
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 13, 'Plain', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 13, 'Rib', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 13, 'Cable', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('4', 0, 13, 'Intarsia', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('5', 0, 13, 'Jacquard', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('6', 0, 13, 'Skashi', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('7', 0, 13, 'Mixed', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('8', 0, 13, 'Mesh', GETDATE(), 1, GETDATE(), '')

INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('9', 0, 13, 'Mohair', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('10', 0, 13, 'Fabric Match', GETDATE(), 1, GETDATE(), '')

INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('98', 0, 13, 'Don''t See', GETDATE(), 1, GETDATE(), '')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('99', 0, 13, 'Null', GETDATE(), 1, GETDATE(), '')

-- Type
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('1', 0, 14, 'TOP', GETDATE(), 1, GETDATE(), 'upper clothes, like shirts, coats.')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('2', 0, 14, 'BOTTOM', GETDATE(), 1, GETDATE(), 'bottom clothes, like trousers, skirts.')
INSERT [dbo].[CategoryItem] ([CategoryItemValue], [Status], [CategoryId], [CategoryItemName], [CreateTime], [OperaterId], [LastUpdateTime], [Description]) VALUES ('3', 0, 14, 'COORDI', GETDATE(), 1, GETDATE(), 'clothes inside the coat.')

